Car prediction profile

Dataset statistics

Number of variables	13
Number of observations	15411
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	162
Duplicate rows (%)	1.1%
Total size in memory	1.6 MiB
Average record size in memory	112.0 B

Variable types

Text	2
Categorical	4
Numeric	7

Alerts

Dataset has 162 (1.1%) duplicate rows	Duplicates
`brand` is highly overall correlated with `engine` and 3 other fields	High correlation
`engine` is highly overall correlated with `brand` and 2 other fields	High correlation
`km_driven` is highly overall correlated with `vehicle_age`	High correlation
`max_power` is highly overall correlated with `brand` and 4 other fields	High correlation
`mileage` is highly overall correlated with `max_power`	High correlation
`selling_price` is highly overall correlated with `brand` and 2 other fields	High correlation
`transmission_type` is highly overall correlated with `brand` and 1 other fields	High correlation
`vehicle_age` is highly overall correlated with `km_driven`	High correlation
`fuel_type` is highly imbalanced (50.6%)	Imbalance
`km_driven` is highly skewed (γ1 = 28.17271087)	Skewed

Reproduction

Analysis started	2025-02-18 12:49:42.349404
Analysis finished	2025-02-18 12:49:50.134020
Duration	7.78 seconds
Software version	ydata-profiling vv4.12.2
Download configuration	config.json

car_name
Text

Distinct	121
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	240.8 KiB

Length

Max length	22
Median length	19
Mean length	12.612809
Min length	5

Characters and Unicode

Total characters	194376
Distinct characters	62
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	9 ?
Unique (%)	0.1%

Sample

1st row	Maruti Alto
2nd row	Hyundai Grand
3rd row	Hyundai i20
4th row	Maruti Alto
5th row	Ford Ecosport

Value	Count	Frequency (%)
maruti	4992	15.4%
hyundai	2982	9.2%
swift	1671	5.1%
honda	1485	4.6%
mahindra	1011	3.1%
dzire	913	2.8%
i20	906	2.8%
toyota	793	2.4%
ford	790	2.4%
alto	778	2.4%
Other values (142)	16182	49.8%

Most occurring characters

Value	Count	Frequency (%)
a	21446	11.0%
	17092	8.8%
i	16613	8.5%
r	12836	6.6%
t	12474	6.4%
o	11542	5.9%
n	11422	5.9%
u	9577	4.9%
d	8077	4.2%
e	7444	3.8%
Other values (52)	65853	33.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	137070	70.5%
Uppercase Letter	34981	18.0%
Space Separator	17092	8.8%
Decimal Number	4413	2.3%
Dash Punctuation	820	0.4%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
M	6855	19.6%
H	4548	13.0%
S	2721	7.8%
C	2345	6.7%
V	2316	6.6%
R	1748	5.0%
D	1614	4.6%
A	1575	4.5%
W	1565	4.5%
T	1493	4.3%
Other values (16)	8201	23.4%

Lowercase Letter

Value	Count	Frequency (%)
a	21446	15.6%
i	16613	12.1%
r	12836	9.4%
t	12474	9.1%
o	11542	8.4%
n	11422	8.3%
u	9577	7.0%
d	8077	5.9%
e	7444	5.4%
y	4621	3.4%
Other values (14)	21018	15.3%

Decimal Number

Value	Count	Frequency (%)
0	2073	47.0%
2	906	20.5%
1	491	11.1%
5	473	10.7%
3	190	4.3%
4	112	2.5%
6	94	2.1%
7	60	1.4%
9	8	0.2%
8	6	0.1%

Space Separator

Value	Count	Frequency (%)
	17092	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	820	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	172051	88.5%
Common	22325	11.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	21446	12.5%
i	16613	9.7%
r	12836	7.5%
t	12474	7.3%
o	11542	6.7%
n	11422	6.6%
u	9577	5.6%
d	8077	4.7%
e	7444	4.3%
M	6855	4.0%
Other values (40)	53765	31.2%

Common

Value	Count	Frequency (%)
	17092	76.6%
0	2073	9.3%
2	906	4.1%
-	820	3.7%
1	491	2.2%
5	473	2.1%
3	190	0.9%
4	112	0.5%
6	94	0.4%
7	60	0.3%
Other values (2)	14	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	194376	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	21446	11.0%
	17092	8.8%
i	16613	8.5%
r	12836	6.6%
t	12474	6.4%
o	11542	5.9%
n	11422	5.9%
u	9577	4.9%
d	8077	4.2%
e	7444	3.8%
Other values (52)	65853	33.9%

brand
Categorical

High correlation

Distinct	32
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	240.8 KiB

Maruti	4992
Hyundai	2982
Honda	1485
Mahindra	1011
Toyota	793
Other values (27)	4148

Length

Max length	13
Median length	12
Mean length	6.2812277
Min length	2

Characters and Unicode

Total characters	96800
Distinct characters	43
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	< 0.1%

Sample

1st row	Maruti
2nd row	Hyundai
3rd row	Hyundai
4th row	Maruti
5th row	Ford

Common Values

Value	Count	Frequency (%)
Maruti	4992	32.4%
Hyundai	2982	19.3%
Honda	1485	9.6%
Mahindra	1011	6.6%
Toyota	793	5.1%
Ford	790	5.1%
Volkswagen	620	4.0%
Renault	536	3.5%
BMW	439	2.8%
Tata	430	2.8%
Other values (22)	1333	8.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
maruti	4992	32.3%
hyundai	2982	19.3%
honda	1485	9.6%
mahindra	1011	6.5%
toyota	793	5.1%
ford	790	5.1%
volkswagen	620	4.0%
renault	536	3.5%
bmw	439	2.8%
tata	430	2.8%
Other values (22)	1384	9.0%

Most occurring characters

Value	Count	Frequency (%)
a	15011	15.5%
i	9257	9.6%
u	8957	9.3%
r	7268	7.5%
n	7223	7.5%
d	7183	7.4%
t	6926	7.2%
M	6819	7.0%
o	4930	5.1%
H	4467	4.6%
Other values (33)	18759	19.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	79702	82.3%
Uppercase Letter	16708	17.3%
Dash Punctuation	339	0.4%
Space Separator	51	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	15011	18.8%
i	9257	11.6%
u	8957	11.2%
r	7268	9.1%
n	7223	9.1%
d	7183	9.0%
t	6926	8.7%
o	4930	6.2%
y	3779	4.7%
e	2682	3.4%
Other values (11)	6486	8.1%

Uppercase Letter

Value	Count	Frequency (%)
M	6819	40.8%
H	4467	26.7%
T	1223	7.3%
F	792	4.7%
B	779	4.7%
V	640	3.8%
R	589	3.5%
W	439	2.6%
S	336	2.0%
A	193	1.2%
Other values (10)	431	2.6%

Dash Punctuation

Value	Count	Frequency (%)
-	339	100.0%

Space Separator

Value	Count	Frequency (%)
	51	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	96410	99.6%
Common	390	0.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	15011	15.6%
i	9257	9.6%
u	8957	9.3%
r	7268	7.5%
n	7223	7.5%
d	7183	7.5%
t	6926	7.2%
M	6819	7.1%
o	4930	5.1%
H	4467	4.6%
Other values (31)	18369	19.1%

Common

Value	Count	Frequency (%)
-	339	86.9%
	51	13.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	96800	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	15011	15.5%
i	9257	9.6%
u	8957	9.3%
r	7268	7.5%
n	7223	7.5%
d	7183	7.4%
t	6926	7.2%
M	6819	7.0%
o	4930	5.1%
H	4467	4.6%
Other values (33)	18759	19.4%

model
Text

Distinct	120
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	240.8 KiB

Length

Max length	12
Median length	9
Mean length	5.3315813
Min length	1

Characters and Unicode

Total characters	82165
Distinct characters	62
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	8 ?
Unique (%)	0.1%

Sample

1st row	Alto
2nd row	Grand
3rd row	i20
4th row	Alto
5th row	Ecosport

Value	Count	Frequency (%)
swift	1671	9.8%
dzire	913	5.4%
i20	906	5.3%
alto	778	4.6%
city	757	4.4%
wagon	717	4.2%
r	717	4.2%
grand	580	3.4%
innova	545	3.2%
verna	492	2.9%
Other values (111)	8965	52.6%

Most occurring characters

Value	Count	Frequency (%)
i	7356	9.0%
o	6612	8.0%
a	6435	7.8%
r	5568	6.8%
t	5548	6.8%
e	4762	5.8%
n	4199	5.1%
l	2415	2.9%
S	2385	2.9%
C	2345	2.9%
Other values (52)	34540	42.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	57368	69.8%
Uppercase Letter	18273	22.2%
Decimal Number	4413	5.4%
Space Separator	1630	2.0%
Dash Punctuation	481	0.6%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
S	2385	13.1%
C	2345	12.8%
V	1676	9.2%
D	1444	7.9%
A	1382	7.6%
R	1159	6.3%
W	1126	6.2%
E	1077	5.9%
I	947	5.2%
G	810	4.4%
Other values (16)	3922	21.5%

Lowercase Letter

Value	Count	Frequency (%)
i	7356	12.8%
o	6612	11.5%
a	6435	11.2%
r	5568	9.7%
t	5548	9.7%
e	4762	8.3%
n	4199	7.3%
l	2415	4.2%
z	2028	3.5%
f	1771	3.1%
Other values (14)	10674	18.6%

Decimal Number

Value	Count	Frequency (%)
0	2073	47.0%
2	906	20.5%
1	491	11.1%
5	473	10.7%
3	190	4.3%
4	112	2.5%
6	94	2.1%
7	60	1.4%
9	8	0.2%
8	6	0.1%

Space Separator

Value	Count	Frequency (%)
	1630	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	481	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	75641	92.1%
Common	6524	7.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	7356	9.7%
o	6612	8.7%
a	6435	8.5%
r	5568	7.4%
t	5548	7.3%
e	4762	6.3%
n	4199	5.6%
l	2415	3.2%
S	2385	3.2%
C	2345	3.1%
Other values (40)	28016	37.0%

Common

Value	Count	Frequency (%)
0	2073	31.8%
	1630	25.0%
2	906	13.9%
1	491	7.5%
-	481	7.4%
5	473	7.3%
3	190	2.9%
4	112	1.7%
6	94	1.4%
7	60	0.9%
Other values (2)	14	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	82165	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	7356	9.0%
o	6612	8.0%
a	6435	7.8%
r	5568	6.8%
t	5548	6.8%
e	4762	5.8%
n	4199	5.1%
l	2415	2.9%
S	2385	2.9%
C	2345	2.9%
Other values (52)	34540	42.0%

vehicle_age
Real number (ℝ)

High correlation

Distinct	24
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.0363377

Minimum	0
Maximum	29
Zeros	5
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	240.8 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	4
median	6
Q3	8
95-th percentile	12
Maximum	29
Range	29
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	3.0132915
Coefficient of variation (CV)	0.499192
Kurtosis	0.76006867
Mean	6.0363377
Median Absolute Deviation (MAD)	2
Skewness	0.83371202
Sum	93026
Variance	9.0799254
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
4	2252	14.6%
5	2117	13.7%
3	1926	12.5%
6	1924	12.5%
7	1438	9.3%
8	1282	8.3%
2	1145	7.4%
9	1027	6.7%
10	710	4.6%
11	551	3.6%
Other values (14)	1039	6.7%

Value	Count	Frequency (%)
0	5	< 0.1%
1	221	1.4%
2	1145	7.4%
3	1926	12.5%
4	2252	14.6%
5	2117	13.7%
6	1924	12.5%
7	1438	9.3%
8	1282	8.3%
9	1027	6.7%

Value	Count	Frequency (%)
29	1	< 0.1%
25	1	< 0.1%
22	1	< 0.1%
21	3	< 0.1%
19	5	< 0.1%
18	11	0.1%
17	17	0.1%
16	25	0.2%
15	90	0.6%
14	129	0.8%

km_driven
Real number (ℝ)

High correlation Skewed

Distinct	3688
Distinct (%)	23.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	55616.481

Minimum	100
Maximum	3800000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	240.8 KiB

Quantile statistics

Minimum	100
5-th percentile	10000
Q1	30000
median	50000
Q3	70000
95-th percentile	120000
Maximum	3800000
Range	3799900
Interquartile range (IQR)	40000

Descriptive statistics

Standard deviation	51618.548
Coefficient of variation (CV)	0.92811605
Kurtosis	1846.5268
Mean	55616.481
Median Absolute Deviation (MAD)	20000
Skewness	28.172711
Sum	8.5710558 × 10⁸
Variance	2.6644745 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
50000	553	3.6%
40000	477	3.1%
70000	466	3.0%
60000	449	2.9%
30000	363	2.4%
80000	352	2.3%
35000	334	2.2%
25000	323	2.1%
20000	298	1.9%
120000	293	1.9%
Other values (3678)	11503	74.6%

Value	Count	Frequency (%)
100	1	< 0.1%
581	1	< 0.1%
1000	10	0.1%
1001	3	< 0.1%
1005	1	< 0.1%
1010	1	< 0.1%
1041	1	< 0.1%
1100	1	< 0.1%
1198	1	< 0.1%
1200	6	< 0.1%

Value	Count	Frequency (%)
3800000	1	< 0.1%
1325000	1	< 0.1%
950000	1	< 0.1%
850000	1	< 0.1%
830000	1	< 0.1%
825000	1	< 0.1%
820000	1	< 0.1%
720000	1	< 0.1%
675000	1	< 0.1%
590000	1	< 0.1%

seller_type
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	240.8 KiB

Dealer	9539
Individual	5699
Trustmark Dealer	173

Length

Max length	16
Median length	6
Mean length	7.5914606
Min length	6

Characters and Unicode

Total characters	116992
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Individual
2nd row	Individual
3rd row	Individual
4th row	Individual
5th row	Dealer

Common Values

Value	Count	Frequency (%)
Dealer	9539	61.9%
Individual	5699	37.0%
Trustmark Dealer	173	1.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
dealer	9712	62.3%
individual	5699	36.6%
trustmark	173	1.1%

Most occurring characters

Value	Count	Frequency (%)
e	19424	16.6%
a	15584	13.3%
l	15411	13.2%
i	11398	9.7%
d	11398	9.7%
r	10058	8.6%
D	9712	8.3%
u	5872	5.0%
n	5699	4.9%
I	5699	4.9%
Other values (7)	6737	5.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	101235	86.5%
Uppercase Letter	15584	13.3%
Space Separator	173	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	19424	19.2%
a	15584	15.4%
l	15411	15.2%
i	11398	11.3%
d	11398	11.3%
r	10058	9.9%
u	5872	5.8%
n	5699	5.6%
v	5699	5.6%
s	173	0.2%
Other values (3)	519	0.5%

Uppercase Letter

Value	Count	Frequency (%)
D	9712	62.3%
I	5699	36.6%
T	173	1.1%

Space Separator

Value	Count	Frequency (%)
	173	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	116819	99.9%
Common	173	0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	19424	16.6%
a	15584	13.3%
l	15411	13.2%
i	11398	9.8%
d	11398	9.8%
r	10058	8.6%
D	9712	8.3%
u	5872	5.0%
n	5699	4.9%
I	5699	4.9%
Other values (6)	6564	5.6%

Common

Value	Count	Frequency (%)
	173	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	116992	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	19424	16.6%
a	15584	13.3%
l	15411	13.2%
i	11398	9.7%
d	11398	9.7%
r	10058	8.6%
D	9712	8.3%
u	5872	5.0%
n	5699	4.9%
I	5699	4.9%
Other values (7)	6737	5.8%

fuel_type
Categorical

Imbalance

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	240.8 KiB

Petrol	7643
Diesel	7419
CNG	301
LPG	44
Electric	4

Length

Max length	8
Median length	6
Mean length	5.9333593
Min length	3

Characters and Unicode

Total characters	91439
Distinct characters	15
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Petrol
2nd row	Petrol
3rd row	Petrol
4th row	Petrol
5th row	Diesel

Common Values

Value	Count	Frequency (%)
Petrol	7643	49.6%
Diesel	7419	48.1%
CNG	301	2.0%
LPG	44	0.3%
Electric	4	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
petrol	7643	49.6%
diesel	7419	48.1%
cng	301	2.0%
lpg	44	0.3%
electric	4	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
e	22485	24.6%
l	15066	16.5%
P	7687	8.4%
t	7647	8.4%
r	7647	8.4%
o	7643	8.4%
i	7423	8.1%
D	7419	8.1%
s	7419	8.1%
G	345	0.4%
Other values (5)	658	0.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	75338	82.4%
Uppercase Letter	16101	17.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	22485	29.8%
l	15066	20.0%
t	7647	10.2%
r	7647	10.2%
o	7643	10.1%
i	7423	9.9%
s	7419	9.8%
c	8	< 0.1%

Uppercase Letter

Value	Count	Frequency (%)
P	7687	47.7%
D	7419	46.1%
G	345	2.1%
C	301	1.9%
N	301	1.9%
L	44	0.3%
E	4	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	91439	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	22485	24.6%
l	15066	16.5%
P	7687	8.4%
t	7647	8.4%
r	7647	8.4%
o	7643	8.4%
i	7423	8.1%
D	7419	8.1%
s	7419	8.1%
G	345	0.4%
Other values (5)	658	0.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	91439	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	22485	24.6%
l	15066	16.5%
P	7687	8.4%
t	7647	8.4%
r	7647	8.4%
o	7643	8.4%
i	7423	8.1%
D	7419	8.1%
s	7419	8.1%
G	345	0.4%
Other values (5)	658	0.7%

transmission_type
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	240.8 KiB

Manual	12225
Automatic	3186

Length

Max length	9
Median length	6
Mean length	6.6202063
Min length	6

Characters and Unicode

Total characters	102024
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Manual
2nd row	Manual
3rd row	Manual
4th row	Manual
5th row	Manual

Common Values

Value	Count	Frequency (%)
Manual	12225	79.3%
Automatic	3186	20.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
manual	12225	79.3%
automatic	3186	20.7%

Most occurring characters

Value	Count	Frequency (%)
a	27636	27.1%
u	15411	15.1%
M	12225	12.0%
n	12225	12.0%
l	12225	12.0%
t	6372	6.2%
A	3186	3.1%
o	3186	3.1%
m	3186	3.1%
i	3186	3.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	86613	84.9%
Uppercase Letter	15411	15.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	27636	31.9%
u	15411	17.8%
n	12225	14.1%
l	12225	14.1%
t	6372	7.4%
o	3186	3.7%
m	3186	3.7%
i	3186	3.7%
c	3186	3.7%

Uppercase Letter

Value	Count	Frequency (%)
M	12225	79.3%
A	3186	20.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	102024	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	27636	27.1%
u	15411	15.1%
M	12225	12.0%
n	12225	12.0%
l	12225	12.0%
t	6372	6.2%
A	3186	3.1%
o	3186	3.1%
m	3186	3.1%
i	3186	3.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	102024	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	27636	27.1%
u	15411	15.1%
M	12225	12.0%
n	12225	12.0%
l	12225	12.0%
t	6372	6.2%
A	3186	3.1%
o	3186	3.1%
m	3186	3.1%
i	3186	3.1%

mileage
Real number (ℝ)

High correlation

Distinct	411
Distinct (%)	2.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	19.701151

Minimum	4
Maximum	33.54
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	240.8 KiB

Quantile statistics

Minimum	4
5-th percentile	12.8
Q1	17
median	19.67
Q3	22.7
95-th percentile	26.59
Maximum	33.54
Range	29.54
Interquartile range (IQR)	5.7

Descriptive statistics

Standard deviation	4.1712646
Coefficient of variation (CV)	0.21172695
Kurtosis	-0.16752504
Mean	19.701151
Median Absolute Deviation (MAD)	2.87
Skewness	0.10496103
Sum	303614.44
Variance	17.399448
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
18.9	632	4.1%
18.6	404	2.6%
17	339	2.2%
24.3	292	1.9%
28.4	279	1.8%
20.51	224	1.5%
20.36	221	1.4%
22	201	1.3%
15.1	199	1.3%
19.7	197	1.3%
Other values (401)	12423	80.6%

Value	Count	Frequency (%)
4	1	< 0.1%
6	1	< 0.1%
7.5	2	< 0.1%
7.81	6	< 0.1%
7.94	1	< 0.1%
8.45	6	< 0.1%
8.5	2	< 0.1%
8.6	1	< 0.1%
8.77	1	< 0.1%
8.9	3	< 0.1%

Value	Count	Frequency (%)
33.54	24	0.2%
33.44	14	0.1%
32.52	13	0.1%
32.26	4	< 0.1%
31.79	16	0.1%
30.48	6	< 0.1%
30.47	3	< 0.1%
30.46	14	0.1%
28.4	279	1.8%
28.09	136	0.9%

engine
Real number (ℝ)

High correlation

Distinct	110
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1486.0578

Minimum	793
Maximum	6592
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	240.8 KiB

Quantile statistics

Minimum	793
5-th percentile	998
Q1	1197
median	1248
Q3	1582
95-th percentile	2523
Maximum	6592
Range	5799
Interquartile range (IQR)	385

Descriptive statistics

Standard deviation	521.1067
Coefficient of variation (CV)	0.35066383
Kurtosis	4.329217
Mean	1486.0578
Median Absolute Deviation (MAD)	249
Skewness	1.6664666
Sum	22901636
Variance	271552.19
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1197	2436	15.8%
1248	1668	10.8%
998	1174	7.6%
1498	1095	7.1%
2179	669	4.3%
1497	662	4.3%
796	501	3.3%
1199	469	3.0%
1396	465	3.0%
1198	437	2.8%
Other values (100)	5835	37.9%

Value	Count	Frequency (%)
793	9	0.1%
796	501	3.3%
799	207	1.3%
998	1174	7.6%
999	228	1.5%
1047	46	0.3%
1061	76	0.5%
1086	288	1.9%
1120	93	0.6%
1186	48	0.3%

Value	Count	Frequency (%)
6592	1	< 0.1%
5998	3	< 0.1%
5461	4	< 0.1%
4806	3	< 0.1%
4663	1	< 0.1%
4395	2	< 0.1%
4367	3	< 0.1%
4163	1	< 0.1%
4134	3	< 0.1%
3855	1	< 0.1%

max_power
Real number (ℝ)

High correlation

Distinct	342
Distinct (%)	2.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	100.58825

Minimum	38.4
Maximum	626
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	240.8 KiB

Quantile statistics

Minimum	38.4
5-th percentile	58.16
Q1	74
median	88.5
Q3	117.3
95-th percentile	184
Maximum	626
Range	587.6
Interquartile range (IQR)	43.3

Descriptive statistics

Standard deviation	42.972979
Coefficient of variation (CV)	0.42721667
Kurtosis	11.881846
Mean	100.58825
Median Absolute Deviation (MAD)	15.5
Skewness	2.4851294
Sum	1550165.6
Variance	1846.6769
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
74	791	5.1%
88.5	589	3.8%
81.8	544	3.5%
98.6	424	2.8%
67.04	390	2.5%
67	338	2.2%
140	319	2.1%
81.86	305	2.0%
82	287	1.9%
47.3	286	1.9%
Other values (332)	11138	72.3%

Value	Count	Frequency (%)
38.4	5	< 0.1%
40.3	14	0.1%
46.3	195	1.3%
47	12	0.1%
47.3	286	1.9%
53	3	< 0.1%
53.26	18	0.1%
53.3	132	0.9%
53.64	54	0.4%
57.5	19	0.1%

Value	Count	Frequency (%)
626	1	< 0.1%
601	1	< 0.1%
600	1	< 0.1%
563	1	< 0.1%
552	1	< 0.1%
500	1	< 0.1%
459	1	< 0.1%
450	1	< 0.1%
440	1	< 0.1%
420	1	< 0.1%

seats
Real number (ℝ)

Distinct	8
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.3254818

Minimum	0
Maximum	9
Zeros	2
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	240.8 KiB

Quantile statistics

Minimum	0
5-th percentile	5
Q1	5
median	5
Q3	5
95-th percentile	7
Maximum	9
Range	9
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.80762843
Coefficient of variation (CV)	0.15165359
Kurtosis	3.7018063
Mean	5.3254818
Median Absolute Deviation (MAD)	0
Skewness	2.0399825
Sum	82071
Variance	0.65226368
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
5	12910	83.8%
7	1922	12.5%
8	311	2.0%
6	127	0.8%
4	77	0.5%
9	55	0.4%
2	7	< 0.1%
0	2	< 0.1%

Value	Count	Frequency (%)
0	2	< 0.1%
2	7	< 0.1%
4	77	0.5%
5	12910	83.8%
6	127	0.8%
7	1922	12.5%
8	311	2.0%
9	55	0.4%

Value	Count	Frequency (%)
9	55	0.4%
8	311	2.0%
7	1922	12.5%
6	127	0.8%
5	12910	83.8%
4	77	0.5%
2	7	< 0.1%
0	2	< 0.1%

selling_price
Real number (ℝ)

High correlation

Distinct	1086
Distinct (%)	7.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	774971.12

Minimum	40000
Maximum	39500000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	240.8 KiB

Quantile statistics

Minimum	40000
5-th percentile	215000
Q1	385000
median	556000
Q3	825000
95-th percentile	2050000
Maximum	39500000
Range	39460000
Interquartile range (IQR)	440000

Descriptive statistics

Standard deviation	894128.36
Coefficient of variation (CV)	1.153757
Kurtosis	281.98064
Mean	774971.12
Median Absolute Deviation (MAD)	206000
Skewness	10.047048
Sum	1.194308 × 10¹⁰
Variance	7.9946553 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
450000	357	2.3%
550000	334	2.2%
650000	330	2.1%
350000	320	2.1%
500000	271	1.8%
400000	265	1.7%
600000	256	1.7%
750000	229	1.5%
300000	228	1.5%
525000	192	1.2%
Other values (1076)	12629	81.9%

Value	Count	Frequency (%)
40000	1	< 0.1%
45000	1	< 0.1%
50000	3	< 0.1%
55000	1	< 0.1%
60000	4	< 0.1%
62000	2	< 0.1%
65000	5	< 0.1%
70000	5	< 0.1%
74000	1	< 0.1%
75000	4	< 0.1%

Value	Count	Frequency (%)
39500000	1	< 0.1%
24200000	1	< 0.1%
14500000	1	< 0.1%
13000000	1	< 0.1%
11100000	1	< 0.1%
11000000	2	< 0.1%
9200000	1	< 0.1%
8500000	2	< 0.1%
8250000	1	< 0.1%
8200000	1	< 0.1%

	brand	engine	fuel_type	km_driven	max_power	mileage	seats	seller_type	selling_price	transmission_type	vehicle_age
brand	1.000	0.613	0.243	0.000	0.565	0.433	0.371	0.184	0.701	0.580	0.112
engine	0.613	1.000	0.270	0.273	0.828	-0.498	0.455	0.098	0.643	0.401	0.090
fuel_type	0.243	0.270	1.000	0.000	0.184	0.323	0.182	0.077	0.030	0.085	0.111
km_driven	0.000	0.273	0.000	1.000	0.096	-0.097	0.198	0.000	-0.166	0.010	0.576
max_power	0.565	0.828	0.184	0.096	1.000	-0.508	0.243	0.135	0.722	0.577	-0.029
mileage	0.433	-0.498	0.323	-0.097	-0.508	1.000	-0.426	0.093	-0.279	0.305	-0.232
seats	0.371	0.455	0.182	0.198	0.243	-0.426	1.000	0.063	0.266	0.123	0.024
seller_type	0.184	0.098	0.077	0.000	0.135	0.093	0.063	1.000	0.045	0.204	0.093
selling_price	0.701	0.643	0.030	-0.166	0.722	-0.279	0.266	0.045	1.000	0.233	-0.477
transmission_type	0.580	0.401	0.085	0.010	0.577	0.305	0.123	0.204	0.233	1.000	0.089
vehicle_age	0.112	0.090	0.111	0.576	-0.029	-0.232	0.024	0.093	-0.477	0.089	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

	car_name	brand	model	vehicle_age	km_driven	seller_type	fuel_type	transmission_type	mileage	engine	max_power	seats	selling_price
0	Maruti Alto	Maruti	Alto	9	120000	Individual	Petrol	Manual	19.70	796	46.30	5	120000
1	Hyundai Grand	Hyundai	Grand	5	20000	Individual	Petrol	Manual	18.90	1197	82.00	5	550000
2	Hyundai i20	Hyundai	i20	11	60000	Individual	Petrol	Manual	17.00	1197	80.00	5	215000
3	Maruti Alto	Maruti	Alto	9	37000	Individual	Petrol	Manual	20.92	998	67.10	5	226000
4	Ford Ecosport	Ford	Ecosport	6	30000	Dealer	Diesel	Manual	22.77	1498	98.59	5	570000
5	Maruti Wagon R	Maruti	Wagon R	8	35000	Individual	Petrol	Manual	18.90	998	67.10	5	350000
6	Hyundai i10	Hyundai	i10	8	40000	Dealer	Petrol	Manual	20.36	1197	78.90	5	315000
7	Maruti Wagon R	Maruti	Wagon R	3	17512	Dealer	Petrol	Manual	20.51	998	67.04	5	410000
8	Hyundai Venue	Hyundai	Venue	2	20000	Individual	Petrol	Automatic	18.15	998	118.35	5	1050000
12	Maruti Swift	Maruti	Swift	4	28321	Dealer	Petrol	Manual	16.60	1197	85.00	5	511000

	car_name	brand	model	vehicle_age	km_driven	seller_type	fuel_type	transmission_type	mileage	engine	max_power	seats	selling_price
19531	Maruti Swift	Maruti	Swift	3	25000	Individual	Petrol	Automatic	22.00	1197	81.80	5	590000
19533	Honda Amaze	Honda	Amaze	6	28000	Dealer	Diesel	Manual	25.80	1498	98.60	5	525000
19534	Renault KWID	Renault	KWID	2	2700	Dealer	Petrol	Manual	25.17	799	53.30	5	395000
19535	Maruti Ertiga	Maruti	Ertiga	5	56829	Dealer	Diesel	Manual	20.77	1248	88.80	7	895000
19536	Hyundai Grand	Hyundai	Grand	5	9229	Dealer	Petrol	Manual	18.90	1197	82.00	5	545000
19537	Hyundai i10	Hyundai	i10	9	10723	Dealer	Petrol	Manual	19.81	1086	68.05	5	250000
19540	Maruti Ertiga	Maruti	Ertiga	2	18000	Dealer	Petrol	Manual	17.50	1373	91.10	7	925000
19541	Skoda Rapid	Skoda	Rapid	6	67000	Dealer	Diesel	Manual	21.14	1498	103.52	5	425000
19542	Mahindra XUV500	Mahindra	XUV500	5	3800000	Dealer	Diesel	Manual	16.00	2179	140.00	7	1225000
19543	Honda City	Honda	City	2	13000	Dealer	Petrol	Automatic	18.00	1497	117.60	5	1200000

Most frequently occurring

	car_name	brand	model	vehicle_age	km_driven	seller_type	fuel_type	transmission_type	mileage	engine	max_power	seats	selling_price	# duplicates
10	Ford Endeavour	Ford	Endeavour	3	48000	Dealer	Diesel	Automatic	10.91	3198	197.00	7	2899000	3
74	Maruti Alto	Maruti	Alto	3	20000	Individual	Petrol	Manual	24.70	796	47.30	5	310000	3
98	Maruti Swift	Maruti	Swift	8	80000	Individual	Diesel	Manual	22.90	1248	74.00	5	350000	3
155	Toyota Camry	Toyota	Camry	7	53000	Dealer	Petrol	Automatic	12.98	2494	178.30	5	1099000	3
157	Volkswagen Polo	Volkswagen	Polo	4	55000	Dealer	Petrol	Manual	16.20	1199	74.00	5	675000	3
0	Audi A4	Audi	A4	5	51000	Dealer	Diesel	Automatic	18.25	1968	187.74	5	1850000	2
1	Audi A4	Audi	A4	9	68370	Dealer	Diesel	Automatic	17.11	1968	174.33	5	1345000	2
2	BMW 5	BMW	5	0	2000	Dealer	Diesel	Automatic	22.48	1995	187.74	5	4850000	2
3	BMW 6	BMW	6	3	11000	Dealer	Diesel	Automatic	17.09	2993	261.40	4	5600000	2
4	BMW 7	BMW	7	13	70000	Dealer	Petrol	Automatic	8.45	2979	321.00	5	750000	2

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Decimal Number

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Dash Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Decimal Number

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length